from django.db import models
# Create your models here.
class job_table(models.Model):
    job_id = models.CharField(max_length=256)             
    description = models.CharField(max_length=256)        
    submiter = models.CharField(max_length=128)           
    test_case_repo = models.CharField(max_length=256)     
    result_repo = models.CharField(max_length=256)        
    test_excutables = models.CharField(max_length=256)    
    test_case_range = models.CharField(max_length=256)    
    have_child = models.CharField(max_length=16)          
    parent = models.CharField(max_length=128)             
    cmd = models.CharField(max_length=256)                
    argument = models.CharField(max_length=256)           
    agent_get_it = models.CharField(max_length=256)       
    be_getted_time = models.CharField(max_length=128)     
    status = models.CharField(max_length=32)              
    finish_rate = models.CharField(max_length=32)         
    total_num = models.CharField(max_length=32)           
    finished_num = models.CharField(max_length=32)        
    passed_num = models.CharField(max_length=32)          
    code_coverage = models.CharField(max_length=64)       
    code_coverage_path = models.CharField(max_length=256) 
    test_case_num = models.CharField(max_length=64)       

class request_table(models.Model):
    request_id = models.CharField(max_length=128)       'varchar(128)',
    submiter = models.CharField(max_length=64)           'varchar(64)',
    email = models.CharField(max_length=128)              'varchar(128)',
    submit_time = = models.CharField(max_length=64)         'varchar(64)',
    time_zone_offset = = models.CharField(max_length=64)    'varchar(64)',
    content = models.CharField(max_length=256)             'longtext',
    status = models.CharField(max_length=16)             'varchar(16)',
    workspace_dir = models.CharField(max_length=256)      'varchar(256)',
    result_dir = models.CharField(max_length=256)         'varchar(256)',
    excution_end_time = models.CharField(max_length=256) 'varchar(64)',
    excution_start_time = models.CharField(max_length=256)'varchar(64)',
    code_coverage = models.CharField(max_length=256)      'varchar(64)',
    code_coverage_path = models.CharField(max_length=256) 'varchar(256)',
    type = models.CharField(max_length=256)                'varchar(16)'

class test_plan_table(models.Model):
    ID  = models.CharField(max_length=256)              'varchar(200)',
    description = models.CharField(max_length=256)      'varchar(150)',
    cmd = models.CharField(max_length=256)              'varchar(100)',
    argument = models.CharField(max_length=256)         'varchar(250)',
    test_case_range = models.CharField(max_length=256)  'varchar(250)',
    test_case_number = models.CharField(max_length=256) 'varchar(20)',
    test_excutables = models.CharField(max_length=256)  'varchar(250)',
    test_case_repo = models.CharField(max_length=256)   'varchar(250)',
    duations = models.CharField(max_length=256)          'varchar(250)',
    child = models.CharField(max_length=256)            'varchar(10)',
    parent = models.CharField(max_length=256)           'varchar(100)'
class agent_table(models.Model):
    name = models.CharField(max_length=256)		 'varchar(64)',
    agent_ip = models.CharField(max_length=256)		 'varchar(32)',
    agent_port = models.CharField(max_length=256)	 'varchar(16)',
    status = models.CharField(max_length=256)		 'varchar(32)',
    timer = models.CharField(max_length=256)		 '100',
    test_type = models.CharField(max_length=256)	 ''
